Kelly Moore
Kelly Moore
-
Re: Extract Date from Date and Time in Date Column
Hey @Xochitl C. You can use the TIME function to convert to values recognized as time. The MID function allows you to extract from the middle of an existing textstring. =TIME(MID(Timestamp@row, FIND(…1 · -
Re: Help with WEEKNUMBER formula
Hello @Xochitl C. I'm happy to help. To help me clarify - were you expecting the formula above to produce the combined week number and month text string, or was that formula meant to do something els…1 · -
Re: Indexing and collecting information from non adjacent columns in original sheet
Hey @Rachael Stammers So glad you got it working. As you continue to grow your formulas, consider the good practice of renaming the generically assigned cross sheet reference names from smartsheet. F…1 · -
Re: Request: Report summaries should count checked = 1 and unchecked = 0 for Checkbox columns
Hey @CMathews Add a filter to your report where Flag column 'is checked'. This will only count the flagged flags. If you want a count of both, don't add the filter but add a grouping on the Flag colu…2 · -
Re: Is the column type "Modified Date" a date column?
Hey @JLK Did you change your formula column, [Days Pending], to a date column? Your Max formula will return a date, as @Anjanesh Vaidya's screenshot indicates. Kelly1 ·
